﻿using System;
using System.Collections.Generic;

using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;



public partial class vp_Billing_StockVariance : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        GridView1.DataSource = GetTable();
        GridView1.DataBind();
    }



    private DataTable GetTable()
    {

        DataTable dtbl1 = new DataTable();


        dtbl1.Columns.Add("Agent Name", typeof(string));
        dtbl1.Columns.Add("Order No", typeof(string));
        dtbl1.Columns.Add("Category Code", typeof(string));
        dtbl1.Columns.Add("Sub Category Code", typeof(string));
        dtbl1.Columns.Add("Amount", typeof(string));
        dtbl1.Columns.Add("Limit Amount", typeof(string));


        dtbl1.Rows.Add("Agent1", "OR0001", "Category01", "SubCategory01", "1000", "800");
        dtbl1.Rows.Add("Agent2", "OR0001", "Category01", "SubCategory01", "1000", "800");
        dtbl1.Rows.Add("Agent3", "OR0001", "Category01", "SubCategory01", "1000", "800");


        return dtbl1;
    }
}






